package com.example.zhongcao.mapper;

import com.example.zhongcao.entity.ZhongcaoSign;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ZhongcaoSignMapper {
    @Insert("insert into zhongcao_sign(zhongcaoid,signname) values(#{zhongcaoid},#{signname})")
    void insertZCS(ZhongcaoSign zcs);

    @Select("select signname from zhongcao_sign where zhongcaoid=#{zhongcaoid}")
    List<String> selectAllsignsById(Integer zhongcaoid);

    @Delete("delete from zhongcao_sign where zhongcaoid=#{zhongcaoid}")
    void deleteAllPics(Integer zhongcaoid);
}
